Skip Headers

Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# NAME

NAME is a special dimension that is used by Oracle OLAP to organize the list of objects in a workspace. Its values are the names of the objects defined in the current workspace. (

You cannot explicitly change the values of the NAME dimension. Instead the values are changed as DEFINE, DELETE, MOVE, or RENAME statements execute. Also, you cannot use a qualified object name to specify the NAME dimension of a workspace that is not the current workspace.

See also: LISTNAMES

Data type

TEXT

Syntax

NAME

Examples

Example 18-12 Listing Dimensions

Suppose you want a list of all the dimensions in a workspace. First, use a LIMIT command and the OBJ function to limit the status of the NAME dimension. Then use a STATUS statement to produce a list of dimensions. Since the values returned by `OBJ(TYPE)` are always in uppercase, you must use `'DIMENSION'` (not `'dimension'`) in the LIMIT statement to get a match. The statements

    LIMIT NAME TO OBJ(TYPE) EQ 'DIMENSION'
    STATUS NAME

produce the following output.

    The current status of NAME is:
    PRODUCT, DISTRICT, DIVISION, LINE, REGION, MARKETLEVEL, MARKET,
    MONTH, YEAR, QUARTER

Example 18-13 Listing Relations

Suppose you want to see the definitions of all the relations in a workspace. Use the LIMIT command and the OBJ function to select these names. Then use DESCRIBE to produce a list of their definitions. The statements

    LIMIT NAME TO OBJ(TYPE) EQ 'RELATION'
    DESCRIBE

produce the following output.

    DEFINE REGION.DISTRICT RELATION REGION <DISTRICT>
    LD REGION for each DISTRICT

    DEFINE DIVISION.PRODUCT RELATION DIVISION <PRODUCT>
    LD DIVISION for each PRODUCT

    DEFINE MLV.MARKET RELATION MARKETLEVEL <MARKET>

    DEFINE MARKET.MARKET RELATION MARKET <MARKET>
    LD Self-relation for the Market Dimension